SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_VerifyEmployer]
    (
      @JOL_Employer_Account VARCHAR(50),
      @JOL_Employer_VerifyStatus VARCHAR(50),
      @JOL_Employer_VerifyUser VARCHAR(50)
    )
AS 
    UPDATE  dbo.JOL_Employer
    SET     JOL_Employer_VerifyStatus = @JOL_Employer_VerifyStatus,
            JOL_Employer_VerifyUser = @JOL_Employer_VerifyUser,
            JOL_Employer_VerifyTime = GETDATE()
    WHERE   JOL_Employer_Account = @JOL_Employer_Account
GO
